﻿CREATE TABLE [dbo].[Receivable] (
    [ID_Receivable]       INT           IDENTITY (1, 1) NOT NULL,
    [Id_Client]           INT           NOT NULL,
    [DocumentNumber]      VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Description]         VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
    [DocumentDate]        SMALLDATETIME NULL,
    [PaymentDate]         SMALLDATETIME NOT NULL,
    [ExpectedPaymentDate] SMALLDATETIME NULL,
    [Id_CostCenter]       INT           NULL,
    [Id_Account]          INT           NOT NULL,
    [Id_BankTransaction]  INT           NOT NULL,
    [Amount]              MONEY         NULL
);

